IF NOT EXISTS(SELECT name FROM sysobjects  WHERE name = 'EPOTracking')
BEGIN 

CREATE TABLE [dbo].[EPOTracking](
	[Id] [UNIQUEIDENTIFIER] NOT NULL,
	[OrderId] [BIGINT] NULL,
	[NationalCode] [VARCHAR](12) NULL,
	[Mobile] [VARCHAR](12) NULL,
	[TrackingCode] [VARCHAR](20) NULL,
	[InsuranceType] [TINYINT] NULL,
	[SupplemetaryName] [NVARCHAR](MAX) NULL,
	[CreatedOn] [DATETIME] NULL,
	[Description] [NVARCHAR](MAX) NULL,
	[OrderDate] [DATETIME] NULL,
	[DeliveryDateInfo] [NVARCHAR](MAX) NULL,
	[Status] [TINYINT] NULL,
	[QueueNumber] [SMALLINT] NULL,
	[IsPaid] [BIT] NULL,
	[PrescriptionId] [DECIMAL](18, 0) NULL,
	[UpdatedOn] [DATETIME] NULL,
	[FullName] [NVARCHAR](200) NULL,
	[OrderJson] [NVARCHAR](MAX) NULL,
      [DeliveryAddress] [NVARCHAR](MAX) NULL,
 CONSTRAINT [PK_EPOTracking] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
) ON [PRIMARY]
) ON [PRIMARY] 


ALTER TABLE [dbo].[EPOTracking] ADD  CONSTRAINT [DF_EPOTracking_Id]  DEFAULT (NEWID()) FOR [Id]


ALTER TABLE [dbo].[EPOTracking] ADD  CONSTRAINT [DF_EPOTracking_CreatedOn]  DEFAULT (GETDATE()) FOR [CreatedOn]


ALTER TABLE [dbo].[EPOTracking] ADD  CONSTRAINT [DF_EPOTracking_IsPaid]  DEFAULT ((0)) FOR [IsPaid]


End